<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
    "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<!--

    Licensed to the Apache Software Foundation (ASF) under one
    or more contributor license agreements.  See the NOTICE file
    distributed with this work for additional information
    regarding copyright ownership.  The ASF licenses this file
    to you under the Apache License, Version 2.0 (the
    "License"); you may not use this file except in compliance
    with the License.  You may obtain a copy of the License at

      http://www.apache.org/licenses/LICENSE-2.0

    Unless required by applicable law or agreed to in writing,
    software distributed under the License is distributed on an
    "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
    KIND, either express or implied.  See the License for the
    specific language governing permissions and limitations
    under the License.

-->
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en" dir="ltr">
<head>
<title>Profile Window with SQL Queries</title>
<link rel="stylesheet" href="ide.css" title="Oracle BLAFDoc" type="text/css"/>
</head>

<body>
<p><a id="ProfileSQL.HelpCtx" name="ProfileSQL.HelpCtx"></a></p>
<!-- infolevel="all" infotype="General" --><a id="sthref449" name="sthref449"></a>
<h1>Profile Window with SQL Queries</h1>
<a name="BEGIN" id="BEGIN"></a>
<p>Use to monitor and capture data during a SQL queries session.</p>
<p>The following table shows the available actions.</p>

<table summary="User interface elements and descriptions" dir="ltr" border="1" width="100%" frame="hsides" rules="groups" cellpadding="3" cellspacing="0">
<col width="31%" />
<col width="*" />
<thead>
<tr align="left" valign="top">
<th align="left" valign="bottom" id="r1c1-t42">Element</th>
<th align="left" valign="bottom" id="r1c2-t42">Description</th>
</tr>
</thead>
<tbody>
<tr align="left" valign="top">
<td align="left" id="r2c1-t42" headers="r1c1-t42">
<p>Results</p>
</td>
<td align="left" headers="r2c1-t42 r1c2-t42"></td>
</tr>
<tr align="left" valign="top">
<td align="left" id="r3c1-t42" headers="r1c1-t42">
<p><img width="19" height="19" src="img/pause_live_results.png" alt="Pause live results icon" title="Pause live results icon" />Pause live results</p>
</td>
<td align="left" headers="r3c1-t42 r1c2-t42">Click to pause the live results display.</td>
</tr>
<tr align="left" valign="top">
<td align="left" id="r4c1-t42" headers="r1c1-t42">
<p><img width="21" height="20" src="img/update_live_results.png" alt="Update live results icon" title="Update live results icon" />Update live results</p>
</td>
<td align="left" headers="r4c1-t42 r1c2-t42">Click to update the live results display.</td>
</tr>
<tr align="left" valign="top">
<td align="left" id="r5c1-t42" headers="r1c1-t42">
<p><img width="18" height="17" src="img/show_delta_values.png" alt="Show delta values icon" title="Show delta values icon" />Show delta values</p>
</td>
<td align="left" headers="r5c1-t42 r1c2-t42">Click to either show delta values or absolute values.</td>
</tr>
<tr align="left" valign="top">
<td align="left" id="r6c1-t42" headers="r1c1-t42">Collected Data</td>
<td align="left" headers="r6c1-t42 r1c2-t42"></td>
</tr>
<tr align="left" valign="top">
<td align="left" id="r7c1-t42" headers="r1c1-t42">
<p><img width="20" height="20" src="img/take_snapshot.png" alt="Take snapshot icon" title="Take snapshot icon" />Snapshot</p>
</td>
<td align="left" headers="r7c1-t42 r1c2-t42">Click to take a snapshot of the session.</td>
</tr>
<tr align="left" valign="top">
<td align="left" id="r8c1-t42" headers="r1c1-t42">
<p><img width="16" height="16" src="img/reset_results.png" alt="Reset collected results icon" title="Reset collected results icon" />Reset Collected Results</p>
</td>
<td align="left" headers="r8c1-t42 r1c2-t42">Click to reset the collected results.</td>
</tr>
<tr align="left" valign="top">
<td align="left" id="r9c1-t42" headers="r1c1-t42">Process</td>
<td align="left" headers="r9c1-t42 r1c2-t42"></td>
</tr>
<tr align="left" valign="top">
<td align="left" id="r10c1-t42" headers="r1c1-t42">
<p><img width="18" height="18" src="img/take_thread_dump.png" alt="Thread dump icon" title="Thread dump icon" />Thread Dump</p>
</td>
<td align="left" headers="r10c1-t42 r1c2-t42">Click to create a textual dump of all active threads and monitors of the profiled application.</td>
</tr>
<tr align="left" valign="top">
<td align="left" id="r11c1-t42" headers="r1c1-t42">
<p><img width="17" height="17" src="img/take_heap_dump.png" alt="Heap dump icon" title="Heap dump icon" />Heap Dump</p>
</td>
<td align="left" headers="r11c1-t42 r1c2-t42">Click to save an image of the current heap content of the profiled process in .hprof format.</td>
</tr>
<tr align="left" valign="top">
<td align="left" id="r12c1-t42" headers="r1c1-t42">
<p><img width="18" height="20" src="img/gc.png" alt="Garbage collection icon" title="Garbage collection icon" />GC</p>
</td>
<td align="left" headers="r12c1-t42 r1c2-t42">Click to request the JVM of the profiled process to invoke garbage collection.</td>
</tr>
<tr align="left" valign="top">
<td align="left" id="r13c1-t42" headers="r1c1-t42"><img width="17" height="17" src="img/settings.png" alt="Settings button" title="Settings button" />Settings</td>
<td align="left" headers="r13c1-t42 r1c2-t42">Click to display and select or hide the profiling options: All queries or Defined queries.</td>
</tr>
<tr align="left" valign="top">
<td align="left" id="r14c1-t42" headers="r1c1-t42">Profile</td>
<td align="left" headers="r14c1-t42 r1c2-t42"></td>
</tr>
<tr align="left" valign="top">
<td align="left" id="r15c1-t42" headers="r1c1-t42">All Queries</td>
<td align="left" headers="r15c1-t42 r1c2-t42">Displays and profiles all queries contained in your application.</td>
</tr>
<tr align="left" valign="top">
<td align="left" id="r16c1-t42" headers="r1c1-t42">Defined Queries</td>
<td align="left" headers="r16c1-t42 r1c2-t42">Displays and profiles specified queries in your application.</td>
</tr>
<tr align="left" valign="top">
<td align="left" id="r17c1-t42" headers="r1c1-t42">SQL Query</td>
<td align="left" headers="r17c1-t42 r1c2-t42">Displays a list of queries. You can sort the list by clicking a column heading.</td>
</tr>
<tr align="left" valign="top">
<td align="left" id="r18c1-t42" headers="r1c1-t42">Total Time</td>
<td align="left" headers="r18c1-t42 r1c2-t42">Displays total of time spent on a SQL query. You can sort the list by clicking a column heading.</td>
</tr>
<tr align="left" valign="top">
<td align="left" id="r19c1-t42" headers="r1c1-t42">Invocations</td>
<td align="left" headers="r19c1-t42 r1c2-t42">Displays the number of the selected query invocations. You can sort the list by clicking a column heading.</td>
</tr>
<tr align="left" valign="top">
<td align="left" id="r20c1-t42" headers="r1c1-t42">Statement Type</td>
<td align="left" headers="r20c1-t42 r1c2-t42">Displays the type of an SQL query. The options are: Callable, Prepared, Regular. You can sort the list by clicking a column heading.</td>
</tr>
<tr align="left" valign="top">
<td align="left" id="r21c1-t42" headers="r1c1-t42">Command Type</td>
<td align="left" headers="r21c1-t42 r1c2-t42">Displays the type of a SQL command (for example, Select or Delete). You can sort the list by clicking a column heading.</td>
</tr>
<tr align="left" valign="top">
<td align="left" id="r22c1-t42" headers="r1c1-t42">Table</td>
<td align="left" headers="r22c1-t42 r1c2-t42">Displays the name of a database table that a SQL query accesses. You can sort the list by clicking a column heading.</td>
</tr>
<tr align="left" valign="top">
<td align="left" id="r23c1-t42" headers="r1c1-t42">Statements</td>
<td align="left" headers="r23c1-t42 r1c2-t42"></td>
</tr>
<tr align="left" valign="top">
<td align="left" id="r24c1-t42" headers="r1c1-t42">Regular</td>
<td align="left" headers="r24c1-t42 r1c2-t42">Select to display queries with regular Statements in the SQL Query table.</td>
</tr>
<tr align="left" valign="top">
<td align="left" id="r25c1-t42" headers="r1c1-t42">Prepared</td>
<td align="left" headers="r25c1-t42 r1c2-t42">Select to display queries with PreparedStatements in the SQL Query table.</td>
</tr>
<tr align="left" valign="top">
<td align="left" id="r26c1-t42" headers="r1c1-t42">Callable</td>
<td align="left" headers="r26c1-t42 r1c2-t42">Select to display queries with CallableStatements in the SQL Query table.</td>
</tr>
<tr align="left" valign="top">
<td align="left" id="r27c1-t42" headers="r1c1-t42">Commands</td>
<td align="left" headers="r27c1-t42 r1c2-t42">Specify the value of a command for a query to be displayed in the SQL Query table.</td>
</tr>
<tr align="left" valign="top">
<td align="left" id="r28c1-t42" headers="r1c1-t42">Tables</td>
<td align="left" headers="r28c1-t42 r1c2-t42">Specify the value of a table for a query to be displayed in the SQL Query table.</td>
</tr>
<tr align="left" valign="top">
<td align="left" id="r29c1-t42" headers="r1c1-t42">Apply</td>
<td align="left" headers="r29c1-t42 r1c2-t42">Click to apply the selected Statements options and specified Commands and Tables options.</td>
</tr>
<tr align="left" valign="top">
<td align="left" id="r30c1-t42" headers="r1c1-t42">Filter</td>
<td align="left" headers="r30c1-t42 r1c2-t42">Specify the value of a filter.</td>
</tr>
<tr align="left" valign="top">
<td align="left" id="r31c1-t42" headers="r1c1-t42"><img width="21" height="19" src="img/filter_sql.png" alt="Filter results" title="Filter results" />Filter results</td>
<td align="left" headers="r31c1-t42 r1c2-t42">Click to apply the specified filter.</td>
</tr>
<tr align="left" valign="top">
<td align="left" id="r32c1-t42" headers="r1c1-t42">Filter type</td>
<td align="left" headers="r32c1-t42 r1c2-t42">Opens a submenu that enables you to select a filter for the types of queries to display. You can select any of the following filters:</td>
</tr>
<tr align="left" valign="top">
<td align="left" id="r33c1-t42" headers="r1c1-t42"><img width="21" height="19" src="img/contains.png" alt="Contains" title="Contains" />Contains</td>
<td align="left" headers="r33c1-t42 r1c2-t42">Displays queries that contain the specified filter value.</td>
</tr>
<tr align="left" valign="top">
<td align="left" id="r34c1-t42" headers="r1c1-t42"><img width="20" height="19" src="img/does_not_contain.png" alt="Does not contain" title="Does not contain" />Does Not Contain</td>
<td align="left" headers="r34c1-t42 r1c2-t42">Displays queries that do not contain the specified filter value.</td>
</tr>
<tr align="left" valign="top">
<td align="left" id="r35c1-t42" headers="r1c1-t42"><img width="20" height="20" src="img/reg_expression.png" alt="Regular expession" title="Regular expession" />Regular Expression</td>
<td align="left" headers="r35c1-t42 r1c2-t42">Displays queries that contain the specified regular expression.</td>
</tr>
<tr align="left" valign="top">
<td align="left" id="r36c1-t42" headers="r1c1-t42"><img width="19" height="18" src="img/match_case.png" alt="Match case" title="Match case" />Match case</td>
<td align="left" headers="r36c1-t42 r1c2-t42">Click to filter for the queries that match the case of the specified filter value.</td>
</tr>
</tbody>
</table>
<br />
<!-- -->
<a id="sthref450" name="sthref450"></a>
<hr><p><b>Related Topics</b></p>
<p><i>Developing Applications with NetBeans IDE</i>, 
<object classid="java:org.netbeans.modules.javahelp.BrowserDisplayer">
<param name="content" value="http://www.oracle.com/pls/topic/lookup?ctx=nb8200&id=NBDAG659">
<param name="text" value="<html><u>&quot;Testing and Profiling Java Application Projects&quot;</u></html>">
<param name="textFontSize" value="medium">
<param name="textColor" value="blue">
</object>
</p>

<!-- -->
<!-- Start Footer -->


<table summary="" cellspacing="0" cellpadding="0" width="100%">
<tr>
<td align="left" width="86%"><a href="legal_notice.htm">
Licensed to the Apache Software Foundation (ASF) under one or more contributor license agreements; and to You under the Apache License, Version 2.0.</a>
</td>
</tr>
</table>
<!-- -->
</body>
</html>
